﻿Public Class AquariumFishGateway
    Inherits DataGateway

    Protected Overrides ReadOnly Property FindAllQuery As String
        Get
            Return "SELECT * FROM AquariumFishView"
        End Get
    End Property

    Protected Overrides ReadOnly Property DeleteQuery As String
        Get
            Return "DELETE FROM AquariumFish"
        End Get
    End Property

    Protected Overrides ReadOnly Property SiteUserQuery() As String
        Get
            Return "SELECT SiteUser.* " &
                   "FROM Aquarium LEFT JOIN SiteUser " &
                   "ON Aquarium.UserID=SiteUser.ID " &
                   "WHERE Aquarium.ID=@ID"
        End Get
    End Property
End Class
